View definition and schema search path bug or expected behaviour?

Поиск
Список
Период
Сортировка
От Chris Bartlett
Тема View definition and schema search path bug or expected behaviour?
Дата
Msg-id p06240806cc365805b15e@[192.168.200.4]
обсуждение исходный текст
Ответы Re: View definition and schema search path bug or expected behaviour?  (Adrian Klaver <adrian.klaver@gmail.com>)
Список pgsql-general
I am not sure if this is expected behaviour or a bug.

Using PG 9.2 beta 2 and PGAdmin3 1.16 beta 2.

Connect as bob (superuser)

In public schema:
   create table people (cols...)
   create view people_view as select * from people

Create schema bob
   create table bob.people (cols...)
   create view bob.people_view as select * from people
   (NB: view references people, not bob.people)

Insert a record into bob.people

Select * from bob.people_view
   -> Nil result set
   (expected to return the record from bob.people)

Check definition of bob.people_view
   -> "create view bob.people_view as select * from public.people"
   (NB: "from public.people" - compare "create view bob.people_view as
select * from people" above)

I had hoped/expected that a view would use the search path to find
the table it references. Why does bob.people_view reference
public.people? Is this a bug or expected behaviour? Do view
definitions require explicit reference to schema.table? My use case
is that I effectively want to define a default schema to be
replicated for new tenants in a multi-tenant system.

В списке pgsql-general по дате отправления:

Предыдущее
От: Craig Ringer
Дата:
Сообщение: Re: Smaller data types use same disk space
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: View definition and schema search path bug or expected behaviour?